Tabela AccountDataInvoice

Definicja tabeli AccountDataInvoice

Name

AccountDataInvoice

Code

AccountDataInvoice

Comment

informacje dotyczace faktur na zakup produktów innych zwiazanych z rozliczaniem produktów jednostkowych


Lista kolumn tabeli AccountDataInvoice

Name

Code

AccountDataInvoiceId

AccountDataInvoiceId

AccountDataID

AccountDataID

TaxpayerId

TaxpayerId

InvoiceNo

InvoiceNo

PositionInInvoice

PositionInInvoice

Active

Active

Amount

Amount

Value

Value

PerfDt

PerfDt


Kolumna AccountDataInvoiceId tabeli AccountDataInvoice

Definicja kolumny AccountDataInvoiceId tabeli AccountDataInvoice

Name

AccountDataInvoiceId

Code

AccountDataInvoiceId

Data Type

NUMBER(12)

Mandatory

Yes

Comment

 


Kolumna AccountDataID tabeli AccountDataInvoice

Definicja kolumny AccountDataID tabeli AccountDataInvoice

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TaxpayerId tabeli AccountDataInvoice

Definicja kolumny TaxpayerId tabeli AccountDataInvoice

Name

TaxpayerId

Code

TaxpayerId

Data Type

VARCHAR2(13)

Mandatory

No

Comment

NIP sprzedajacego


Kolumna InvoiceNo tabeli AccountDataInvoice

Definicja kolumny InvoiceNo tabeli AccountDataInvoice

Name

InvoiceNo

Code

InvoiceNo

Data Type

VARCHAR2(25)

Mandatory

No

Comment

Numer faktury


Kolumna PositionInInvoice tabeli AccountDataInvoice

Definicja kolumny PositionInInvoice tabeli AccountDataInvoice

Name

PositionInInvoice

Code

PositionInInvoice

Data Type

NUMBER(7)

Mandatory

No

Comment

Numer pozycji na fakturze


Kolumna Active tabeli AccountDataInvoice

Definicja kolumny Active tabeli AccountDataInvoice

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Aktywnosc rekordu


Kolumna Amount tabeli AccountDataInvoice

Definicja kolumny Amount tabeli AccountDataInvoice

Name

Amount

Code

Amount

Data Type

NUMBER(14,5)

Mandatory

No

Comment

Ilosc podanej substancji / leku


Kolumna Value tabeli AccountDataInvoice

Definicja kolumny Value tabeli AccountDataInvoice

Name

Value

Code

Value

Data Type

NUMBER(14,6)

Mandatory

No

Comment

Wartosc produktu


Kolumna PerfDt tabeli AccountDataInvoice

Definicja kolumny PerfDt tabeli AccountDataInvoice

Name

PerfDt

Code

PerfDt

Data Type

DATE

Mandatory

No

Comment

Data wystawienia faktury


Lista kluczy tabeli AccountDataInvoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AccountDataInvoice

Definicja klucza Identifier_1 tabeli AccountDataInvoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment